package cn.edu.zhku.citrusmonitor.qa.service;

import java.sql.SQLException;
import java.util.List;

import cn.edu.zhku.citrusmonitor.domain.QA;
import cn.edu.zhku.citrusmonitor.domain.TbQuestion;
import cn.edu.zhku.citrusmonitor.util.PageBean;


public interface QuestionService {
	
	//上传问腿
	public void addQ(TbQuestion q) throws SQLException;
	
	//删除问腿
	public int  removeQ(String questionId) throws SQLException;
	
	//修改问题
	public int modifyQ(TbQuestion q) throws SQLException;
	
	//根据关键字查找已经回答的问题
	public List<TbQuestion> findQAByWord(String content) throws SQLException;
	
	//分页显示已经回答问题
	public List<TbQuestion> showQ(int currentPage, int pageSize, String status) throws SQLException;

	public QA showQAByQid(String questionId) throws SQLException;

	public List<TbQuestion> showQAll(int pageSize);

	public int showQCount(String status) throws SQLException;

	public String findUserPasswordById(String userId) throws SQLException;

	public PageBean<TbQuestion> showAll(int currentPage, int pageSize) throws SQLException;

	public int delAll(String[] ids) throws SQLException;
	
}
